List<!field#>Lineup Card<!field#><!field#>2:0<!field#>SELECT s.BatOrder AS 'Order', p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, p.Jersey AS Jersey, s.PosInn1 AS 'Inn 1', s.PosInn2 AS 'Inn 2', s.PosInn3 AS 'Inn 3', s.PosInn4 AS 'Inn 4', s.PosInn5 AS 'Inn 5', s.PosInn6 AS 'Inn 6', "" AS Notes FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.batted='1' AND s.GameID = '#idx#' <!field#>false<!field#>0<!field#>1<!field#>0<!field#>0<!line#>ListField<!field#>5<!field#>s.BatOrder<!field#>Order<!field#>2<!field#>1<!field#>true<!field#>1.5*<!field#><!line#>ListField<!field#>5<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>2<!field#>true<!field#>4*<!field#>TOTALS<!line#>ListField<!field#>5<!field#>p.Jersey<!field#>Jersey<!field#>2<!field#>3<!field#>true<!field#>1.5*<!field#><!line#>ListField<!field#>5<!field#>s.PosInn1<!field#>Inn 1<!field#>2<!field#>4<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>5<!field#>s.PosInn2<!field#>Inn 2<!field#>2<!field#>5<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>5<!field#>s.PosInn3<!field#>Inn 3<!field#>2<!field#>6<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>5<!field#>s.PosInn4<!field#>Inn 4<!field#>2<!field#>7<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>5<!field#>s.PosInn5<!field#>Inn 5<!field#>2<!field#>8<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>5<!field#>s.PosInn6<!field#>Inn 6<!field#>2<!field#>9<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>5<!field#>""<!field#>Notes<!field#>0<!field#>10<!field#>true<!field#>6*<!field#><!report#>List<!field#>Roster<!field#><!field#>2:0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats-Batting" || s.PlayerID || ".html" AS Player, p.Jersey AS Jersey, p.Bats AS Bats, p.Throws AS Throws, p.Height AS Height, p.Weight AS Weight, p.Age AS Age, p.Phone AS Phone, p.Email AS Email FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.GameID = '#idx#' <!field#>false<!field#>0<!field#>1<!field#>0<!field#>0<!line#>ListField<!field#>6<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats-Batting" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>2*<!field#>TOTALS<!line#>ListField<!field#>6<!field#>p.Jersey<!field#>Jersey<!field#>2<!field#>2<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Bats<!field#>Bats<!field#>2<!field#>3<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Throws<!field#>Throws<!field#>2<!field#>4<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Height<!field#>Height<!field#>2<!field#>5<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Weight<!field#>Weight<!field#>2<!field#>6<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Age<!field#>Age<!field#>2<!field#>7<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Phone<!field#>Phone<!field#>2<!field#>8<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>6<!field#>p.Email<!field#>Email<!field#>2<!field#>9<!field#>true<!field#>2*<!field#><!report#>List<!field#>Game Results<!field#><!field#>0<!field#>SELECT g.GameNo AS No, g.GameDate AS Date, g.Opponent AS Opponent, g.GameType AS Type, g.StartTime AS 'Start Time', g.Result || ", " || g.Score || "#link#" || "Boxscore" || s.GameID || ".html" AS Result, (SELECT SUM(CASE WHEN g2.Result like 'W%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'L%' THEN 1 ELSE 0 END) FROM Games g2 WHERE g2.GameNo <= g.GameNo) AS Record, (SELECT SUM(CASE WHEN g2.Result like 'W%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'L%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'T%' THEN 1 ELSE 0 END) FROM Games g2 WHERE g2.GameNo <= g.GameNo) AS 'Record wTies', sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.Strikeouts) AS SO, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Errors) AS E, sum(s.IP) AS IP, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  GROUP BY g.ID UNION SELECT '-' AS No, '' AS Date, 'TOTALS' AS Opponent, '' AS Type, '' AS 'Start Time', '' AS Result, '' AS Record, '' AS 'Record wTies', sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.Strikeouts) AS SO, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Errors) AS E, sum(s.IP) AS IP, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  <!field#>true<!field#>0<!field#>1<!field#>1<!field#>0<!line#>ListField<!field#>7<!field#>g.GameNo<!field#>No<!field#>2<!field#>1<!field#>true<!field#>1*<!field#>-<!line#>ListField<!field#>7<!field#>g.GameDate<!field#>Date<!field#>0<!field#>2<!field#>false<!field#>2*<!field#><!line#>ListField<!field#>7<!field#>g.Opponent<!field#>Opponent<!field#>0<!field#>3<!field#>true<!field#>2*<!field#>TOTALS<!line#>ListField<!field#>7<!field#>g.GameType<!field#>Type<!field#>2<!field#>4<!field#>false<!field#>1*<!field#><!line#>ListField<!field#>7<!field#>g.StartTime<!field#>Start Time<!field#>2<!field#>5<!field#>false<!field#>1*<!field#><!line#>ListField<!field#>7<!field#>g.Result || ", " || g.Score || "#link#" || "Boxscore" || s.GameID || ".html"<!field#>Result<!field#>0<!field#>6<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>7<!field#>(SELECT SUM(CASE WHEN g2.Result like 'W%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'L%' THEN 1 ELSE 0 END) FROM Games g2 WHERE g2.GameNo <= g.GameNo)<!field#>Record<!field#>2<!field#>7<!field#>true<!field#>1.5*<!field#><!line#>ListField<!field#>7<!field#>(SELECT SUM(CASE WHEN g2.Result like 'W%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'L%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'T%' THEN 1 ELSE 0 END) FROM Games g2 WHERE g2.GameNo <= g.GameNo)<!field#>Record wTies<!field#>2<!field#>8<!field#>false<!field#>1*<!field#><!line#>ListField<!field#>7<!field#>sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AB<!field#>2<!field#>9<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.Runs)<!field#>Runs<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)<!field#>Hits<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.Walks)<!field#>BB<!field#>2<!field#>12<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.RBI)<!field#>RBI<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.Strikeouts)<!field#>SO<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AVG<!field#>2<!field#>15<!field#>true<!field#>1.25*<!field#>0.000<!line#>ListField<!field#>7<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate)<!field#>OBP<!field#>2<!field#>16<!field#>true<!field#>1.25*<!field#>0.000<!line#>ListField<!field#>7<!field#>sum(s.Errors)<!field#>E<!field#>2<!field#>17<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.IP)<!field#>IP<!field#>2<!field#>18<!field#>true<!field#>1*<!field#>#0.00<!line#>ListField<!field#>7<!field#>6.0*sum(s.EarnedRuns)/sum(s.IP)<!field#>ERA<!field#>2<!field#>19<!field#>true<!field#>1.25*<!field#>#0.00<!line#>ListField<!field#>7<!field#>sum(s.HitsAllowed)<!field#>H<!field#>2<!field#>20<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.RunsAllowed)<!field#>R<!field#>2<!field#>21<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.WalksAllowed)<!field#>BB<!field#>2<!field#>22<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.SO)<!field#>K<!field#>2<!field#>23<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.Balls + s.Strikes)<!field#>TP<!field#>2<!field#>24<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls)<!field#>SPct<!field#>2<!field#>25<!field#>true<!field#>1.25*<!field#>#0.0%<!line#>ListField<!field#>7<!field#>sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP)<!field#>WHIP<!field#>2<!field#>26<!field#>true<!field#>1.25*<!field#>#0.00<!report#>List<!field#>Overall (All Games)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END) AS GP, sum(s.Plate) AS PA, sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.HitByPitch) AS HBP, sum(s.SafeOnError) AS SOE, sum(s.StrikeOuts) AS SO, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun) AS TB, (sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS SLG, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END) AS GP, sum(s.Plate) AS PA, sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.HitByPitch) AS HBP, sum(s.SafeOnError) AS SOE, sum(s.StrikeOuts) AS SO, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun) AS TB, (sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS SLG, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  <!field#>true<!field#>1<!field#>-1<!field#>2<!field#>1<!line#>ListField<!field#>8<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>5*<!field#>TOTALS<!line#>ListField<!field#>8<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AVG<!field#>2<!field#>2<!field#>true<!field#>2*<!field#>#0.000<!line#>ListField<!field#>8<!field#>sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>3<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Plate)<!field#>PA<!field#>2<!field#>4<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AB<!field#>2<!field#>5<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Runs)<!field#>Runs<!field#>2<!field#>6<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)<!field#>Hits<!field#>2<!field#>7<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Double)<!field#>2B<!field#>2<!field#>8<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Triple)<!field#>3B<!field#>2<!field#>9<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.HomeRun)<!field#>HR<!field#>2<!field#>10<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Walks)<!field#>BB<!field#>2<!field#>11<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.RBI)<!field#>RBI<!field#>2<!field#>12<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.HitByPitch)<!field#>HBP<!field#>2<!field#>13<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.SafeOnError)<!field#>SOE<!field#>2<!field#>14<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.StrikeOuts)<!field#>SO<!field#>2<!field#>15<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.StolenBases)<!field#>SB<!field#>2<!field#>16<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.CaughtStealing)<!field#>CS<!field#>2<!field#>17<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate)<!field#>OBP<!field#>2<!field#>18<!field#>true<!field#>2*<!field#>#0.000<!line#>ListField<!field#>8<!field#>sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun)<!field#>TB<!field#>2<!field#>19<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>(sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>SLG<!field#>2<!field#>20<!field#>true<!field#>2*<!field#>#0.000<!line#>ListField<!field#>8<!field#>sum(s.Errors)<!field#>E<!field#>2<!field#>21<!field#>false<!field#> 1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Putouts)<!field#>PO<!field#>2<!field#>22<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Assists)<!field#>A<!field#>2<!field#>23<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.TotalChances)<!field#>TC<!field#>2<!field#>24<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances)<!field#>FP<!field#>2<!field#>25<!field#>false<!field#>1*<!field#>0.000<!report#>List<!field#>Overall - Pitching (All)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END) AS APP, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, sum(s.Wins) || "-" || sum(s.Losses) AS 'W-L', sum(s.Saves) AS SV, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1' 
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END) AS APP, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, '-' AS 'W-L', sum(s.Saves) AS SV, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1'<!field#>false<!field#>1<!field#>1<!field#>3<!field#>0<!line#>ListField<!field#>9<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>3.166667*<!field#>TOTALS<!line#>ListField<!field#>9<!field#>6.0*sum(s.EarnedRuns)/sum(s.IP)<!field#>ERA<!field#>2<!field#>2<!field#>true<!field#>1*<!field#>#0.00<!line#>ListField<!field#>9<!field#>sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END)<!field#>APP<!field#>2<!field#>3<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.IP)<!field#>IP<!field#>2<!field#>4<!field#>true<!field#>1*<!field#>#0.00<!line#>ListField<!field#>9<!field#>sum(s.HitsAllowed)<!field#>H<!field#>2<!field#>5<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.RunsAllowed)<!field#>R<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.EarnedRuns)<!field#>ER<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.WalksAllowed)<!field#>BB<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.SO)<!field#>K<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.HBP)<!field#>HB<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.Balls)<!field#>B<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.Strikes)<!field#>S<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.Balls + s.Strikes)<!field#>TP<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls)<!field#>SPct<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>9<!field#>sum(s.Wins) || "-" || sum(s.Losses)<!field#>W-L<!field#>2<!field#>15<!field#>true<!field#>1*<!field#>-<!line#>ListField<!field#>9<!field#>sum(s.Saves)<!field#>SV<!field#>2<!field#>16<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>9<!field#>sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP)<!field#>WHIP<!field#>2<!field#>17<!field#>true<!field#>1*<!field#>#0.00<!report#>List<!field#>Overall (Last 5 Games)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END) AS GP, sum(s.Plate) AS PA, sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.HitByPitch) AS HBP, sum(s.SafeOnError) AS SOE, sum(s.StrikeOuts) AS SO, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun) AS TB, (sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS SLG, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5) 
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END) AS GP, sum(s.Plate) AS PA, sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.HitByPitch) AS HBP, sum(s.SafeOnError) AS SOE, sum(s.StrikeOuts) AS SO, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun) AS TB, (sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS SLG, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5)<!field#>true<!field#>1<!field#>-1<!field#>4<!field#>1<!line#>ListField<!field#>10<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>4*<!field#>TOTALS<!line#>ListField<!field#>10<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AVG<!field#>2<!field#>2<!field#>true<!field#> 2*<!field#>#0.000<!line#>ListField<!field#>10<!field#>sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>3<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Plate)<!field#>PA<!field#>2<!field#>4<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AB<!field#>2<!field#>5<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Runs)<!field#>Runs<!field#>2<!field#>6<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)<!field#>Hits<!field#>2<!field#>7<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Double)<!field#>2B<!field#>2<!field#>8<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Triple)<!field#>3B<!field#>2<!field#>9<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.HomeRun)<!field#>HR<!field#>2<!field#>10<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Walks)<!field#>BB<!field#>2<!field#>11<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.RBI)<!field#>RBI<!field#>2<!field#>12<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.HitByPitch)<!field#>HBP<!field#>2<!field#>13<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.SafeOnError)<!field#>SOE<!field#>2<!field#>14<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.StrikeOuts)<!field#>SO<!field#>2<!field#>15<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.StolenBases)<!field#>SB<!field#>2<!field#>16<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.CaughtStealing)<!field#>CS<!field#>2<!field#>17<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate)<!field#>OBP<!field#>2<!field#>18<!field#>true<!field#> 2*<!field#>#0.000<!line#>ListField<!field#>10<!field#>sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun)<!field#>TB<!field#>2<!field#>19<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>(sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>SLG<!field#>2<!field#>20<!field#>true<!field#> 2*<!field#>#0.000<!line#>ListField<!field#>10<!field#>sum(s.Errors)<!field#>E<!field#>2<!field#>21<!field#>false<!field#> 1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Putouts)<!field#>PO<!field#>2<!field#>22<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Assists)<!field#>A<!field#>2<!field#>23<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.TotalChances)<!field#>TC<!field#>2<!field#>24<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances)<!field#>FP<!field#>2<!field#>25<!field#>false<!field#>1*<!field#>0.000<!report#>List<!field#>Overall - Pitching (Last 5 Games)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END) AS APP, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, sum(s.Wins) || "-" || sum(s.Losses) AS 'W-L', sum(s.Saves) AS SV, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5) AND s.pitched='1' 
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END) AS APP, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, '-' AS 'W-L', sum(s.Saves) AS SV, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5) AND s.pitched='1'<!field#>false<!field#>1<!field#>1<!field#>5<!field#>0<!line#>ListField<!field#>11<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>3*<!field#>TOTALS<!line#>ListField<!field#>11<!field#>6.0*sum(s.EarnedRuns)/sum(s.IP)<!field#>ERA<!field#>2<!field#>2<!field#>true<!field#> 1*<!field#>#0.00<!line#>ListField<!field#>11<!field#>sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END)<!field#>APP<!field#>2<!field#>3<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.IP)<!field#>IP<!field#>2<!field#>4<!field#>true<!field#> 1*<!field#>#0.00<!line#>ListField<!field#>11<!field#>sum(s.HitsAllowed)<!field#>H<!field#>2<!field#>5<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.RunsAllowed)<!field#>R<!field#>2<!field#>6<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.EarnedRuns)<!field#>ER<!field#>2<!field#>7<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.WalksAllowed)<!field#>BB<!field#>2<!field#>8<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.SO)<!field#>K<!field#>2<!field#>9<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.HBP)<!field#>HB<!field#>2<!field#>10<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.Balls)<!field#>B<!field#>2<!field#>11<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.Strikes)<!field#>S<!field#>2<!field#>12<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.Balls + s.Strikes)<!field#>TP<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls)<!field#>SPct<!field#>2<!field#>14<!field#>true<!field#> 1*<!field#>#0.0%<!line#>ListField<!field#>11<!field#>sum(s.Wins) || "-" || sum(s.Losses)<!field#>W-L<!field#>2<!field#>15<!field#>true<!field#> 1*<!field#>-<!line#>ListField<!field#>11<!field#>sum(s.Saves)<!field#>SV<!field#>2<!field#>16<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP)<!field#>WHIP<!field#>2<!field#>17<!field#>true<!field#> 1*<!field#>#0.00<!report#>List<!field#>Boxscore<!field#><!field#>2:0<!field#>SELECT s.BatOrder AS 'Order', p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, s.Plate AS PA, s.Plate-s.Walks-s.HitByPitch-s.Sacrifice AS AB, s.Runs AS R, s.Single+s.Double+s.Triple+s.HomeRun AS Hits, s.Double AS '2B', s.Triple AS '3B', s.HomeRun AS HR, s.RBI AS RBI, s.Walks AS BB, s.StrikeOuts AS SO, s.HitByPitch AS HBP, s.StolenBases AS SB, s.CaughtStealing AS CS, s.Sacrifice AS Sac, s.Errors AS E, s.Putouts AS PO, s.Assists AS A, s.TotalChances AS TC, (s.Putouts+s.Assists*1.0)/s.TotalChances AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.batted='1' AND s.GameID = '#idx#'  UNION SELECT '--' AS 'Order', 'TOTALS' AS Player, sum(s.Plate) AS PA, sum(s.Plate)-sum(s.Walks)-sum(s.HitByPitch)-sum(s.Sacrifice) AS AB, sum(s.Runs) AS R, sum(s.Single)+sum(s.Double)+sum(s.Triple)+sum(s.HomeRun) AS Hits, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.RBI) AS RBI, sum(s.Walks) AS BB, sum(s.StrikeOuts) AS SO, sum(s.HitByPitch) AS HBP, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, sum(s.Sacrifice) AS Sac, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, (sum(s.Putouts)+sum(s.Assists)*1.0)/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.batted='1' AND s.GameID = '#idx#' <!field#>true<!field#>0<!field#>1<!field#>6<!field#>1<!line#>ListField<!field#>12<!field#>s.BatOrder<!field#>Order<!field#>2<!field#>1<!field#>true<!field#>1.37931*<!field#>--<!line#>ListField<!field#>12<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>2<!field#>true<!field#>5*<!field#>TOTALS<!line#>ListField<!field#>12<!field#>s.Plate<!field#>PA<!field#>2<!field#>3<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Plate-s.Walks-s.HitByPitch-s.Sacrifice<!field#>AB<!field#>2<!field#>4<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Runs<!field#>R<!field#>2<!field#>5<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Single+s.Double+s.Triple+s.HomeRun<!field#>Hits<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Double<!field#>2B<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Triple<!field#>3B<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.HomeRun<!field#>HR<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.RBI<!field#>RBI<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Walks<!field#>BB<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.StrikeOuts<!field#>SO<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.HitByPitch<!field#>HBP<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.StolenBases<!field#>SB<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.CaughtStealing<!field#>CS<!field#>2<!field#>15<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Sacrifice<!field#>Sac<!field#>2<!field#>16<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Errors<!field#>E<!field#>2<!field#>17<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Putouts<!field#>PO<!field#>2<!field#>18<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.Assists<!field#>A<!field#>2<!field#>19<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>s.TotalChances<!field#>TC<!field#>2<!field#>20<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>(s.Putouts+s.Assists*1.0)/s.TotalChances<!field#>FP<!field#>2<!field#>21<!field#>false<!field#>1*<!field#>0.000<!report#>List<!field#>Boxscore - Pitching<!field#><!field#>2:19<!field#>SELECT s.PitchOrder AS 'Order', p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, s.IP AS IP, s.HitsAllowed AS H, s.RunsAllowed AS R, s.EarnedRuns AS ER, s.WalksAllowed AS BB, s.SO AS K, s.HBP AS HB, s.Balls AS B, s.Strikes AS S, s.Balls + s.Strikes AS TP, s.Strikes*1.0/(s.Strikes+s.Balls) AS SPct FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1' AND s.GameID = '#idx#'  UNION SELECT '' AS 'Order', 'TOTALS' AS Player, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Balls )+sum( s.Strikes) AS TP, sum(s.Strikes)*1.0/(sum(s.Strikes)+sum(s.Balls)) AS SPct FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1' AND s.GameID = '#idx#' <!field#>false<!field#>0<!field#>1<!field#>7<!field#>0<!line#>ListField<!field#>13<!field#>s.PitchOrder<!field#>Order<!field#>2<!field#>1<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>13<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>2<!field#>true<!field#>3*<!field#>TOTALS<!line#>ListField<!field#>13<!field#>s.IP<!field#>IP<!field#>2<!field#>3<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>13<!field#>s.HitsAllowed<!field#>H<!field#>2<!field#>4<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.RunsAllowed<!field#>R<!field#>2<!field#>5<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.EarnedRuns<!field#>ER<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.WalksAllowed<!field#>BB<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.SO<!field#>K<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.HBP<!field#>HB<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Balls<!field#>B<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Strikes<!field#>S<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Balls + s.Strikes<!field#>TP<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Strikes*1.0/(s.Strikes+s.Balls)<!field#>SPct<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0.0%<!report#>List<!field#>Player Stats<!field#><!field#>1:0<!field#>SELECT g.GameNo AS No, g.Opponent  || " ("  || g.Result || ", " || g.Score  || ")" || "#link#" || "Boxscore" || s.GameID || ".html" AS Game, substr(g.GameDate,6,2) || "/" || substr(g.GameDate,9,2) || "/" || substr(g.GameDate,3,2) AS Date, s.BatOrder AS Ord, s.Plate AS PA, s.Plate-s.Walks-s.HitByPitch-s.Sacrifice-s.SacrificeFly AS AB, s.Runs AS R, s.Single+s.Double+s.Triple+s.HomeRun AS H, s.Double AS '2B', s.Triple AS '3B', s.HomeRun AS HR, s.RBI AS RBI, s.Walks AS BB, s.HitByPitch AS HBP, s.SafeOnError AS SOE, s.Strikeouts AS SO, s.StolenBases AS SB, s.CaughtStealing AS CS, (s.Single+s.Double+s.Triple+s.HomeRun)*1.0/(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, (s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/s.Plate AS OBP, s.Single+2*(s.Double)+3*(s.Triple)+4*(s.HomeRun) AS TB, (s.Single+2*(s.Double)+3*(s.Triple)+4*(s.HomeRun))*1.0/(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS SLG, s.Errors AS E, s.Putouts AS PO, s.Assists AS A, s.TotalChances AS TC, (s.Putouts+s.Assists*1.0)/s.TotalChances AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.batted='1' AND s.PlayerID = '#idx#'  UNION SELECT '' AS No, 'TOTALS' AS Game, '' AS Date, '' AS Ord, sum(s.Plate) AS PA, sum(s.Plate)-sum(s.Walks)-sum(s.HitByPitch)-sum(s.Sacrifice)-sum(s.SacrificeFly) AS AB, sum(s.Runs) AS R, sum(s.Single)+sum(s.Double)+sum(s.Triple)+sum(s.HomeRun) AS H, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.RBI) AS RBI, sum(s.Walks) AS BB, sum(s.HitByPitch) AS HBP, sum(s.SafeOnError) AS SOE, sum(s.Strikeouts) AS SO, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, (sum(s.Single)+sum(s.Double)+sum(s.Triple)+sum(s.HomeRun))*1.0/(sum(s.Plate)-sum(s.Walks)-sum(s.HitByPitch)-sum(s.Sacrifice)) AS AVG, (sum(s.Single)+sum(s.Double)+sum(s.Triple)+sum(s.HomeRun)+sum(s.Walks)+sum(s.HitByPitch))*1.0/sum(s.Plate) AS OBP, sum(s.Single)+2*(sum(s.Double))+3*(sum(s.Triple))+4*(sum(s.HomeRun)) AS TB, (sum(s.Single)+2*(sum(s.Double))+3*(sum(s.Triple))+4*(sum(s.HomeRun)))*1.0/(sum(s.Plate)-sum(s.Walks)-sum(s.HitByPitch)-sum(s.Sacrifice)) AS SLG, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, (sum(s.Putouts)+sum(s.Assists)*1.0)/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.batted='1' AND s.PlayerID = '#idx#' <!field#>true<!field#>0<!field#>1<!field#>8<!field#>1<!line#>ListField<!field#>14<!field#>g.GameNo<!field#>No<!field#>2<!field#>1<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>14<!field#>g.Opponent  || " ("  || g.Result || ", " || g.Score  || ")" || "#link#" || "Boxscore" || s.GameID || ".html"<!field#>Game<!field#>0<!field#>2<!field#>true<!field#> 3*<!field#>TOTALS<!line#>ListField<!field#>14<!field#>substr(g.GameDate,6,2) || "/" || substr(g.GameDate,9,2) || "/" || substr(g.GameDate,3,2)<!field#>Date<!field#>2<!field#>3<!field#>true<!field#> 2*<!field#><!line#>ListField<!field#>14<!field#>s.BatOrder<!field#>Ord<!field#>2<!field#>4<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>14<!field#>s.Plate<!field#>PA<!field#>2<!field#>5<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Plate-s.Walks-s.HitByPitch-s.Sacrifice-s.SacrificeFly<!field#>AB<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Runs<!field#>R<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Single+s.Double+s.Triple+s.HomeRun<!field#>H<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Double<!field#>2B<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Triple<!field#>3B<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.HomeRun<!field#>HR<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.RBI<!field#>RBI<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Walks<!field#>BB<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.HitByPitch<!field#>HBP<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.SafeOnError<!field#>SOE<!field#>2<!field#>15<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Strikeouts<!field#>SO<!field#>2<!field#>16<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.StolenBases<!field#>SB<!field#>2<!field#>17<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.CaughtStealing<!field#>CS<!field#>2<!field#>18<!field#>true<!field#>1*<!field#>#0.00<!line#>ListField<!field#>14<!field#>(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AVG<!field#>2<!field#>19<!field#>true<!field#>1*<!field#>0.000<!line#>ListField<!field#>14<!field#>(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/s.Plate<!field#>OBP<!field#>2<!field#>20<!field#>true<!field#>1*<!field#>0.000<!line#>ListField<!field#>14<!field#>s.Single+2*(s.Double)+3*(s.Triple)+4*(s.HomeRun)<!field#>TB<!field#>2<!field#>21<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>(s.Single+2*(s.Double)+3*(s.Triple)+4*(s.HomeRun))*1.0/(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>SLG<!field#>2<!field#>22<!field#>true<!field#>1*<!field#>0.000<!line#>ListField<!field#>14<!field#>s.Errors<!field#>E<!field#>2<!field#>23<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Putouts<!field#>PO<!field#>2<!field#>24<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Assists<!field#>A<!field#>2<!field#>25<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.TotalChances<!field#>TC<!field#>2<!field#>26<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>(s.Putouts+s.Assists*1.0)/s.TotalChances<!field#>FP<!field#>2<!field#>27<!field#>false<!field#>1*<!field#>0.000<!report#>List<!field#>Player Stats - Pitching<!field#><!field#>1:0<!field#>SELECT g.GameNo AS No, g.Opponent  || " ("  || g.Result || ", " || g.Score  || ")" || "#link#" || "Boxscore" || s.GameID || ".html" AS Game, substr(g.GameDate,6,2) || "/" || substr(g.GameDate,9,2) || "/" || substr(g.GameDate,3,2) AS Date, s.PitchOrder AS O, s.IP AS IP, s.HitsAllowed AS H, s.RunsAllowed AS R, s.EarnedRuns AS ER, s.WalksAllowed AS BB, s.SO AS K, s.HBP AS HB, s.Balls AS B, s.Strikes AS S, s.Strikes*1.0/(s.Strikes+s.Balls) AS SPct, s.Balls + s.Strikes AS TP, (s.WalksAllowed+s.HitsAllowed)*1.0/s.IP AS WHIP, 6.0*s.EarnedRuns/s.IP AS ERA FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1' AND s.PlayerID = '#idx#'  UNION SELECT '' AS No, 'TOTALS' AS Game, '' AS Date, '' AS O, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Strikes)*1.0/(sum(s.Strikes)+sum(s.Balls)) AS SPct, sum(s.Balls )+sum( s.Strikes) AS TP, (sum(s.WalksAllowed)+sum(s.HitsAllowed))*1.0/sum(s.IP) AS WHIP, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1' AND s.PlayerID = '#idx#' <!field#>false<!field#>0<!field#>1<!field#>9<!field#>0<!line#>ListField<!field#>15<!field#>g.GameNo<!field#>No<!field#>2<!field#>1<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>15<!field#>g.Opponent  || " ("  || g.Result || ", " || g.Score  || ")" || "#link#" || "Boxscore" || s.GameID || ".html"<!field#>Game<!field#>0<!field#>2<!field#>true<!field#> 3*<!field#>TOTALS<!line#>ListField<!field#>15<!field#>substr(g.GameDate,6,2) || "/" || substr(g.GameDate,9,2) || "/" || substr(g.GameDate,3,2)<!field#>Date<!field#>2<!field#>3<!field#>true<!field#> 2*<!field#><!line#>ListField<!field#>15<!field#>s.PitchOrder<!field#>O<!field#>2<!field#>4<!field#>true<!field#> 1*<!field#><!line#>ListField<!field#>15<!field#>s.IP<!field#>IP<!field#>2<!field#>5<!field#>true<!field#> 1*<!field#>#0.0<!line#>ListField<!field#>15<!field#>s.HitsAllowed<!field#>H<!field#>2<!field#>6<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>15<!field#>s.RunsAllowed<!field#>R<!field#>2<!field#>7<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>15<!field#>s.EarnedRuns<!field#>ER<!field#>2<!field#>8<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>15<!field#>s.WalksAllowed<!field#>BB<!field#>2<!field#>9<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>15<!field#>s.SO<!field#>K<!field#>2<!field#>10<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>15<!field#>s.HBP<!field#>HB<!field#>2<!field#>11<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>15<!field#>s.Balls<!field#>B<!field#>2<!field#>12<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>15<!field#>s.Strikes<!field#>S<!field#>2<!field#>13<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>15<!field#>s.Strikes*1.0/(s.Strikes+s.Balls)<!field#>SPct<!field#>2<!field#>14<!field#>true<!field#> 1*<!field#>#0.0%<!line#>ListField<!field#>15<!field#>s.Balls + s.Strikes<!field#>TP<!field#>2<!field#>15<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>15<!field#>(s.WalksAllowed+s.HitsAllowed)*1.0/s.IP<!field#>WHIP<!field#>2<!field#>16<!field#>true<!field#> 1*<!field#>#0.00<!line#>ListField<!field#>15<!field#>6.0*s.EarnedRuns/s.IP<!field#>ERA<!field#>2<!field#>17<!field#>true<!field#> 1*<!field#>#0.00<!report#>List<!field#>Baseball Statbook (Link)<!field#><!field#>4<!field#>http://BaseballStatbook.com/
Since this is a link-type report only the first line is used and all other lines are ignored (like this one).
<!field#>true<!field#>0<!field#>1<!field#>10<!field#>0<!line#><!report#>List<!field#>Abbreviations (HTML)<!field#><!field#>3<!field#><p>Many of the following definitions come from the excellent Wikipedia website on <a href="http://en.wikipedia.org/wiki/Baseball_statistics" target="_parent">Baseball Statistics</a>. </p>
      <p align="center"><b><font size="4">Batting Statistics</font> </b></p>
      <table width="100%" border="0" cellpadding="7" cellspacing="1" background="../IMAGES/bg.gif">
        <tr valign="middle" class="rowheading">
          <td width="50" align="center"><b>Abbr</b></td>
          <td width="110" nowrap><b>Statistic</b></td>
          <td><b>Definition</b></td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">PG</td>
          <td nowrap class="theBody">Played Game </td>
          <td class="theBody">The player has batted in the selected game </td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">PA</td>
          <td nowrap class="theBody">Plate Appearance </td>
          <td class="theBody">The number of completed batting appearances resulting in at-bats, bases on balls, hit-by-pitches, or sacrifices. (NOTE: At-bats are calculated from this statistic) </td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">1B</td>
          <td nowrap class="theBody">Single</td>
          <td class="theBody">Hits on which batters only reached first base safely</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">2B</td>
          <td nowrap class="theBody">Double</td>
          <td class="theBody">Hits on which batters only reached second base safely</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">3B</td>
          <td nowrap class="theBody">Triple</td>
          <td class="theBody">Hits on which batters only reached third base safely</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">HR</td>
          <td nowrap class="theBody">Home Run </td>
          <td class="theBody">Hits on which the batter successfully touched all four bases, scoring a run and batting in between one and four runs</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">R</td>
          <td nowrap class="theBody">Run</td>
          <td class="theBody">Times reached home base legally and safely</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">RBI</td>
          <td nowrap class="theBody">Runs Batted In </td>
          <td class="theBody">Number of runners who scored due to a batters's action, except when batter grounded into double play or reached on an error</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">BB</td>
          <td nowrap class="theBody">Bases on Balls </td>
          <td class="theBody">(Also called a &quot;walk&quot;) - Times receiving four balls and advancing to first base</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">K</td>
          <td nowrap class="theBody">Strikeout</td>
          <td class="theBody">Number of times that strike three is taken or swung at and missed, or bunted foul</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">HBP</td>
          <td nowrap class="theBody">Hit By Pitch </td>
          <td class="theBody">Times touched by a pitch and awarded first base as a result</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">SB</td>
          <td nowrap class="theBody">Stolen Base </td>
          <td class="theBody">Number of bases advanced other than on batted balls, walks, or hits by pitch</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">CS</td>
          <td nowrap class="theBody">Caught Stealing </td>
          <td class="theBody">Times tagged out when attempting to steal a base or when picked off</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">Sac</td>
          <td nowrap class="theBody">Sacrifice</td>
          <td class="theBody">Number of fly ball outs which allow another runner to score or number of bunt outs which allow another runner to advance</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">SOE</td>
          <td nowrap class="theBody">Safe On Error </td>
          <td class="theBody">Number of times batter reached base as a result of a fielding error by the defensive team </td>
        </tr>
        <tr valign="top">
          <td colspan="3" align="center" class="theBody"><i>Additional statistics which are shown on Reports </i></td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">AB</td>
          <td nowrap class="theBody">At Bats </td>
          <td class="theBody">Batting appearances, not including bases on balls, hit by pitch, sacrifices, interference, or obstruction</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">AVG</td>
          <td nowrap class="theBody">Average</td>
          <td class="theBody">Hits divided by at bats. Also known as Batting Average</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">GP</td>
          <td nowrap class="theBody">Games Played </td>
          <td class="theBody">Number of games played</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">TB</td>
          <td nowrap class="theBody">Total Bases </td>
          <td class="theBody">One for each single, two for each double, three for each triple, and four for each home run</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">SLG</td>
          <td nowrap class="theBody">Slugging Percentage </td>
          <td class="theBody">Total bases divided by at-bats</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">OBP</td>
          <td nowrap class="theBody">On Base Percentage </td>
          <td class="theBody">Times reached base divided by plate appearances</td>
        </tr>
      </table>
      <p align="center" class="pageheading"><b><font size="4">Pitching Statistics </font></b></p>
      <table width="100%" border="0" cellpadding="7" cellspacing="1" background="../IMAGES/bg.gif">
        <tr valign="middle" class="rowheading">
          <td width="50" align="center"><b>Abbr</b></td>
          <td width="110" nowrap><b>Statistic</b></td>
          <td><b>Definition</b></td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">PG</td>
          <td nowrap class="theBody">Played Game </td>
          <td class="theBody">The player has pitched in the selected game </td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">IP</td>
          <td nowrap class="theBody">Innings Pitched </td>
          <td class="theBody">Number of outs recorded while pitching divided by three (NOTE: 1/3 and 2/3 is represented by .1 and .2 respectively) </td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">HA</td>
          <td nowrap class="theBody">Hits Allowed </td>
          <td class="theBody">Total hits allowed</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">R</td>
          <td nowrap class="theBody">Runs Allowed </td>
          <td class="theBody">Total number of runs allowed</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">ER</td>
          <td nowrap class="theBody">Earned Runs </td>
          <td class="theBody">Number of runs that did not occur as a result of errors or passed balls</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">BB</td>
          <td nowrap class="theBody">Bases on Balls </td>
          <td class="theBody">(Also called a &quot;walk&quot;) - Times pitching four balls, allowing runner to advance to first base</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">K</td>
          <td nowrap class="theBody">Strikeout</td>
          <td class="theBody">Number of batters who received strike three</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">HBP</td>
          <td nowrap class="theBody">Hit By Pitch </td>
          <td class="theBody">Times hit a batter with pitch, allowing runner to advance to first base</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">S</td>
          <td nowrap class="theBody">Strikes</td>
          <td class="theBody">Number of balls thrown which result in the ball being hit (foul or fair) or is called a strike by the umpire</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">B</td>
          <td nowrap class="theBody">Balls</td>
          <td class="theBody">Number of balls thrown that is called a ball by the umpire</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">WP</td>
          <td nowrap class="theBody">Wild Pitch </td>
          <td class="theBody">Number of times a runner advances due to a pitcher's poorly thrown pitch</td>
        </tr>
        <tr valign="top">
          <td colspan="3" align="center" class="theBody"><i>Additional statistics which are shown on Reports </i></td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">ERA</td>
          <td nowrap class="theBody">Earned Run Average </td>
          <td class="theBody">Earned runs times innings in a game (usually nine but can be set from the <i>Preferences</i> tab) divided by innings pitched</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">SPct</td>
          <td nowrap class="theBody">Strike Percentage </td>
          <td class="theBody">Numbers of Strikes (S) divided by number of strikes (S) plus balls (B) </td>
        </tr>
        <tr valign="top" class="oddrow">
          <td align="center" class="theBody">WHIP</td>
          <td nowrap class="theBody">Walks + Hits per Innings Pitched </td>
          <td class="theBody">Number of Walks and Hits allowed divided by the total number of Innings Pitched </td>
        </tr>
      </table><!field#>true<!field#>0<!field#>1<!field#>11<!field#>0<!line#><!report#>List<!field#>Overall - Exhibition<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END) AS GP, sum(s.Plate) AS PA, sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.HitByPitch) AS HBP, sum(s.SafeOnError) AS SOE, sum(s.StrikeOuts) AS SO, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun) AS TB, (sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS SLG, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  Where g.GameType="Exhibition"
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END) AS GP, sum(s.Plate) AS PA, sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.HitByPitch) AS HBP, sum(s.SafeOnError) AS SOE, sum(s.StrikeOuts) AS SO, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun) AS TB, (sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS SLG, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  Where g.GameType="Exhibition"<!field#>false<!field#>1<!field#>-1<!field#>12<!field#>1<!line#>ListField<!field#>18<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>4*<!field#>TOTALS<!line#>ListField<!field#>18<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AVG<!field#>2<!field#>2<!field#>true<!field#> 2*<!field#>#0.000<!line#>ListField<!field#>18<!field#>sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>3<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Plate)<!field#>PA<!field#>2<!field#>4<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AB<!field#>2<!field#>5<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Runs)<!field#>Runs<!field#>2<!field#>6<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)<!field#>Hits<!field#>2<!field#>7<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Double)<!field#>2B<!field#>2<!field#>8<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Triple)<!field#>3B<!field#>2<!field#>9<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.HomeRun)<!field#>HR<!field#>2<!field#>10<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Walks)<!field#>BB<!field#>2<!field#>11<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.RBI)<!field#>RBI<!field#>2<!field#>12<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.HitByPitch)<!field#>HBP<!field#>2<!field#>13<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.SafeOnError)<!field#>SOE<!field#>2<!field#>14<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.StrikeOuts)<!field#>SO<!field#>2<!field#>15<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.StolenBases)<!field#>SB<!field#>2<!field#>16<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.CaughtStealing)<!field#>CS<!field#>2<!field#>17<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate)<!field#>OBP<!field#>2<!field#>18<!field#>true<!field#> 2*<!field#>#0.000<!line#>ListField<!field#>18<!field#>sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun)<!field#>TB<!field#>2<!field#>19<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>(sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>SLG<!field#>2<!field#>20<!field#>true<!field#> 2*<!field#>#0.000<!line#>ListField<!field#>18<!field#>sum(s.Errors)<!field#>E<!field#>2<!field#>21<!field#>false<!field#> 1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Putouts)<!field#>PO<!field#>2<!field#>22<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Assists)<!field#>A<!field#>2<!field#>23<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.TotalChances)<!field#>TC<!field#>2<!field#>24<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>18<!field#>sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances)<!field#>FP<!field#>2<!field#>25<!field#>false<!field#>1*<!field#>0.000<!report#>List<!field#>Overall - Pitching (Exhib)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END) AS APP, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, sum(s.Wins) || "-" || sum(s.Losses) AS 'W-L', sum(s.Saves) AS SV, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1' AND g.GameType="Exhibition"
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END) AS APP, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, '-' AS 'W-L', sum(s.Saves) AS SV, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1' AND g.GameType="Exhibition"<!field#>false<!field#>1<!field#>1<!field#>13<!field#>0<!line#>ListField<!field#>19<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>3*<!field#>TOTALS<!line#>ListField<!field#>19<!field#>6.0*sum(s.EarnedRuns)/sum(s.IP)<!field#>ERA<!field#>2<!field#>2<!field#>true<!field#> 1*<!field#>#0.00<!line#>ListField<!field#>19<!field#>sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END)<!field#>APP<!field#>2<!field#>3<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.IP)<!field#>IP<!field#>2<!field#>4<!field#>true<!field#> 1*<!field#>#0.00<!line#>ListField<!field#>19<!field#>sum(s.HitsAllowed)<!field#>H<!field#>2<!field#>5<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.RunsAllowed)<!field#>R<!field#>2<!field#>6<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.EarnedRuns)<!field#>ER<!field#>2<!field#>7<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.WalksAllowed)<!field#>BB<!field#>2<!field#>8<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.SO)<!field#>K<!field#>2<!field#>9<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.HBP)<!field#>HB<!field#>2<!field#>10<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.Balls)<!field#>B<!field#>2<!field#>11<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.Strikes)<!field#>S<!field#>2<!field#>12<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.Balls + s.Strikes)<!field#>TP<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls)<!field#>SPct<!field#>2<!field#>14<!field#>true<!field#> 1*<!field#>#0.0%<!line#>ListField<!field#>19<!field#>sum(s.Wins) || "-" || sum(s.Losses)<!field#>W-L<!field#>2<!field#>15<!field#>true<!field#> 1*<!field#>-<!line#>ListField<!field#>19<!field#>sum(s.Saves)<!field#>SV<!field#>2<!field#>16<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>19<!field#>sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP)<!field#>WHIP<!field#>2<!field#>17<!field#>true<!field#> 1*<!field#>#0.00<!report#>List<!field#>Overall - Post-Season<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END) AS GP, sum(s.Plate) AS PA, sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.HitByPitch) AS HBP, sum(s.SafeOnError) AS SOE, sum(s.StrikeOuts) AS SO, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun) AS TB, (sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS SLG, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  Where g.GameType="Post-Season"
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AVG, sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END) AS GP, sum(s.Plate) AS PA, sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS AB, sum(s.Runs) AS Runs, sum(s.Single+s.Double+s.Triple+s.HomeRun) AS Hits, sum(s.Double) AS '2B', sum(s.Triple) AS '3B', sum(s.HomeRun) AS HR, sum(s.Walks) AS BB, sum(s.RBI) AS RBI, sum(s.HitByPitch) AS HBP, sum(s.SafeOnError) AS SOE, sum(s.StrikeOuts) AS SO, sum(s.StolenBases) AS SB, sum(s.CaughtStealing) AS CS, sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate) AS OBP, sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun) AS TB, (sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) AS SLG, sum(s.Errors) AS E, sum(s.Putouts) AS PO, sum(s.Assists) AS A, sum(s.TotalChances) AS TC, sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances) AS FP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  Where g.GameType="Post-Season"<!field#>false<!field#>1<!field#>-1<!field#>14<!field#>1<!line#>ListField<!field#>20<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>4*<!field#>TOTALS<!line#>ListField<!field#>20<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AVG<!field#>2<!field#>2<!field#>true<!field#> 2*<!field#>#0.000<!line#>ListField<!field#>20<!field#>sum(CASE WHEN s.batted='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>3<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Plate)<!field#>PA<!field#>2<!field#>4<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>AB<!field#>2<!field#>5<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Runs)<!field#>Runs<!field#>2<!field#>6<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun)<!field#>Hits<!field#>2<!field#>7<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Double)<!field#>2B<!field#>2<!field#>8<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Triple)<!field#>3B<!field#>2<!field#>9<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.HomeRun)<!field#>HR<!field#>2<!field#>10<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Walks)<!field#>BB<!field#>2<!field#>11<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.RBI)<!field#>RBI<!field#>2<!field#>12<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.HitByPitch)<!field#>HBP<!field#>2<!field#>13<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.SafeOnError)<!field#>SOE<!field#>2<!field#>14<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.StrikeOuts)<!field#>SO<!field#>2<!field#>15<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.StolenBases)<!field#>SB<!field#>2<!field#>16<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.CaughtStealing)<!field#>CS<!field#>2<!field#>17<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate)<!field#>OBP<!field#>2<!field#>18<!field#>true<!field#> 2*<!field#>#0.000<!line#>ListField<!field#>20<!field#>sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun)<!field#>TB<!field#>2<!field#>19<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>(sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice)<!field#>SLG<!field#>2<!field#>20<!field#>true<!field#> 2*<!field#>#0.000<!line#>ListField<!field#>20<!field#>sum(s.Errors)<!field#>E<!field#>2<!field#>21<!field#>false<!field#> 1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Putouts)<!field#>PO<!field#>2<!field#>22<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Assists)<!field#>A<!field#>2<!field#>23<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.TotalChances)<!field#>TC<!field#>2<!field#>24<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>20<!field#>sum(s.Putouts+s.Assists)*1.0/sum(s.TotalChances)<!field#>FP<!field#>2<!field#>25<!field#>false<!field#>1*<!field#>0.000<!report#>List<!field#>Overall - Pitching (Post)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END) AS APP, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, sum(s.Wins) || "-" || sum(s.Losses) AS 'W-L', sum(s.Saves) AS SV, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1' AND g.GameType="Post-Season"
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, 6.0*sum(s.EarnedRuns)/sum(s.IP) AS ERA, sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END) AS APP, sum(s.IP) AS IP, sum(s.HitsAllowed) AS H, sum(s.RunsAllowed) AS R, sum(s.EarnedRuns) AS ER, sum(s.WalksAllowed) AS BB, sum(s.SO) AS K, sum(s.HBP) AS HB, sum(s.Balls) AS B, sum(s.Strikes) AS S, sum(s.Balls + s.Strikes) AS TP, sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls) AS SPct, '-' AS 'W-L', sum(s.Saves) AS SV, sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP) AS WHIP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.pitched='1' AND g.GameType="Post-Season"<!field#>false<!field#>1<!field#>1<!field#>15<!field#>0<!line#>ListField<!field#>21<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>3*<!field#>TOTALS<!line#>ListField<!field#>21<!field#>6.0*sum(s.EarnedRuns)/sum(s.IP)<!field#>ERA<!field#>2<!field#>2<!field#>true<!field#> 1*<!field#>#0.00<!line#>ListField<!field#>21<!field#>sum(CASE WHEN s.pitched='1' THEN 1 ELSE 0 END)<!field#>APP<!field#>2<!field#>3<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.IP)<!field#>IP<!field#>2<!field#>4<!field#>true<!field#> 1*<!field#>#0.00<!line#>ListField<!field#>21<!field#>sum(s.HitsAllowed)<!field#>H<!field#>2<!field#>5<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.RunsAllowed)<!field#>R<!field#>2<!field#>6<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.EarnedRuns)<!field#>ER<!field#>2<!field#>7<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.WalksAllowed)<!field#>BB<!field#>2<!field#>8<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.SO)<!field#>K<!field#>2<!field#>9<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.HBP)<!field#>HB<!field#>2<!field#>10<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.Balls)<!field#>B<!field#>2<!field#>11<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.Strikes)<!field#>S<!field#>2<!field#>12<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.Balls + s.Strikes)<!field#>TP<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.Strikes)*1.0/sum(s.Strikes+s.Balls)<!field#>SPct<!field#>2<!field#>14<!field#>true<!field#> 1*<!field#>#0.0%<!line#>ListField<!field#>21<!field#>sum(s.Wins) || "-" || sum(s.Losses)<!field#>W-L<!field#>2<!field#>15<!field#>true<!field#> 1*<!field#>-<!line#>ListField<!field#>21<!field#>sum(s.Saves)<!field#>SV<!field#>2<!field#>16<!field#>true<!field#> 1*<!field#>#0<!line#>ListField<!field#>21<!field#>sum(s.WalksAllowed+s.HitsAllowed)*1.0/sum(s.IP)<!field#>WHIP<!field#>2<!field#>17<!field#>true<!field#> 1*<!field#>#0.00<!report#>